DDE

Modified on 2017/07/11 11:15 by Rob Rrickson (CTS) — Categorized as: Uncategorized

T4 supports sending data via DDE to other application providers, such as Microsoft Excel and Open Office.

On the Main tab of the Main Properties you will find the DDE Format option. This allows you to change between Excel and OpenOffice Calc DDE syntax. They are not the same.

To recieve quote data from a particular DDE link MUST have a Quote Board window open and containing the desired market. Then click the ‘DDE’ button on the Quote Board. Right click on a cell in your spreadsheet and choose the ‘Paste’ menu item. This will paste a table of links to T4 that contain the same markets and columns as your Quote Board. Alternatively, you can right click on a single value in the Quote Board and select the ‘Copy DDE Link’ menu item, then paste into your spreadsheet. Only the specific value will be linked.

Again, the market must be displayed in the Quote Board window BEFORE it is linked to your spreadsheet. This also applies if you are loading a saved spreadsheet.